IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'spTdocin_Update')
	BEGIN
		PRINT 'Dropping Procedure spTdocin_Update'
		DROP  Procedure  spTdocin_Update
	END

GO

PRINT 'Creating Procedure spTdocin_Update'
GO
Create Procedure dbo.spTdocin_Update
	( 	  
		@d_folder varchar(50) = null, 
		@d_loc varchar(50) = null, 
		@d_user varchar(50) = null, 
		@d_status varchar(50) = null, 
		@d_datetime DateTime = null
	)
AS
  /* 
    ------------------------------------------------------------------------------
    - Change History
    - --------------
    - Date          Description
    ------------------------------------------------------------------------------
    - 9/27/2007    Initial version Updated
    ------------------------------------------------------------------------------
  */

	-- Declare the required variables

	-- Update the required new record
	UPDATE Tdocin
	SET
		d_loc = @d_loc, 
		d_user = @d_user, 
		d_status = @d_status, 
		d_datetime = @d_datetime		
	WHERE d_folder = @d_folder

	-- Return to calling method
	RETURN
	
GO
